Unable to access MySQL from MyPHPAdmin after setting root password in EasyPHP{WAMP}
Posted
by Codex
on Stack Overflow
See other posts from Stack Overflow
or by Codex
Published on 2010-03-29T19:49:45Z
Indexed on
2010/03/30
1:33 UTC
Read the original article
Hit count: 982
Am a new starter with WAMP and trying to play around my way using the EasyPHP setup. After successful setup on intial launch of MySQL, the page prompted me to set up ROOT password for security reasons.
On setting the password, am no longer able to access MySQL. The error is :
Error
MySQL said: Documentation
1045 - Access denied for user 'root'@'localhost' (using password: NO)
Looked up on the net and tried the following options in the config.inc.php from the phpmyadmin foler:
1] Set the authetication to "http" so that it prompts to enter the username and password
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
2] Set up the correct password in the config file
$cfg['Servers'][$i]['password'] = 'myPwd';
None of them worked.
Can anyone suggest a workaround to access MySQL? Am not fussed about not being able to use the root account but would like to CRUD on the database using other username.
Thanks in advance.
© Stack Overflow or respective owner